Commit0cd9490

authored

Merge pull request#1517 from lowcoder-org/fix/oracle_blob_serialize

#1173: Implemented json serialization of oracle BLOB column type

2 parents42a8018 +7eed7e2 commit0cd9490Copy full SHA for 0cd9490

File tree

-0

lines changed

server/api-service/lowcoder-sdk/src/main/java/org/lowcoder/sdk/plugin/common/sql
- ResultSetParser.java

-0

lines changed

Lines changed: 9 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,7 +1,9 @@`
`1`	`1`	`packageorg.lowcoder.sdk.plugin.common.sql;`
`2`	`2`
	`3`	`+importorg.apache.commons.codec.binary.Base64;`
`3`	`4`	`importorg.jetbrains.annotations.Nullable;`
`4`	`5`
	`6`	`+importjava.sql.Blob;`
`5`	`7`	`importjava.sql.ResultSet;`
`6`	`8`	`importjava.sql.ResultSetMetaData;`
`7`	`9`	`importjava.sql.SQLException;`
`@@ -25,6 +27,7 @@ public class ResultSetParser {`
`25`	`27`	`publicstaticfinalStringDATETIME_COLUMN_TYPE_NAME ="datetime";`
`26`	`28`	`publicstaticfinalStringTIMESTAMP_COLUMN_TYPE_NAME ="timestamp";`
`27`	`29`	`publicstaticfinalStringYEAR_COLUMN_TYPE_NAME ="year";`
	`30`	`+publicstaticfinalStringBLOB_COLUMN_TYPE_NAME ="blob";`
`28`	`31`
`29`	`32`	`publicstaticList<Map<String,Object>>parseRows(ResultSetresultSet)throwsSQLException {`
`30`	`33`	`ResultSetMetaDatametaData =resultSet.getMetaData();`
`@@ -74,6 +77,12 @@ private static Object getValue(ResultSet resultSet, int i, String typeName) thro`
`74`	`77`	`if (YEAR_COLUMN_TYPE_NAME.equalsIgnoreCase(typeName)) {`
`75`	`78`	`returnresultSet.getDate(i).toLocalDate().getYear();`
`76`	`79`	`}`
	`80`	`+if (BLOB_COLUMN_TYPE_NAME.equalsIgnoreCase(typeName)) {`
	`81`	`+//Convert binary data into base64`
	`82`	`+Blobblob =resultSet.getBlob(i);`
	`83`	`+byte[]blobBytes =blob.getBytes(1, (int)blob.length());`
	`84`	`+returnBase64.encodeBase64String(blobBytes);`
	`85`	`+ }`
`77`	`86`	`returnresultSet.getObject(i);`
`78`	`87`	`}`
`79`	`88`

Comments

(0)