ORA-03114: Not connect to Oracle while startup solutions

Recently, one of my Oracle databases can start mount but unable to open.

sqlstartup
...
Total System Global Area                              7629732 bytes Fixed Size                                              60324 bytes Variable Size                                         6627328 bytes Database Buffers                                       409600 bytes Redo Buffers                                           532480 bytes 
...
ORA-03114: Not connect to Oracle

The … Read the rest “ORA-03114: Not connect to Oracle while startup solutions”

SQLException during executeBatch() when I’m handling BatchUpdateException




SQLException during executeBatch() when I’m handling BatchUpdateException

I’m having some trouble with this.
I’m trying to list some data about the queries that failed during an executeUpdate() and I have read that BatchUpdateException can be caught and then get the updateCount, that tell you which … Read the rest “SQLException during executeBatch() when I’m handling BatchUpdateException”

Trying to Connect to Redshift Over AWS Lambda




Trying to Connect to Redshift Over AWS Lambda

I’m using the node-postgres client to my AWS Redshift database.
Locally, I’m able to run the following code in node, getting print statements for “connected” and “successful query. jsonResult: “.
However, when I run this … Read the rest “Trying to Connect to Redshift Over AWS Lambda”

Calling Sqlserver stored procedure from JDBC,Java




Calling Sqlserver stored procedure from JDBC,Java

I can run this query from toad sql server.
exec msp_FormBsBa_yeni 0,’20150101′,’20150131′,5000,0,2,0,null,1,null,0

from my application in java, it generated error as the statement did not return resultset. i tried many things , but i could not solve it. Thank … Read the rest “Calling Sqlserver stored procedure from JDBC,Java”

How-to: Grails 3.0.2 + Oracle Database 12c?




How-to: Grails 3.0.2 + Oracle Database 12c?

I am making my first steps with Grails and try to create a hello world application with an Oracle Database 12c.
Unfortunately the tutorial documentation on the database specific part at www.grails.org seems not that comprehensive (in contrast … Read the rest “How-to: Grails 3.0.2 + Oracle Database 12c?”

Error java.sql.SQLException: not implemented by SQLite JDBC driver when Retrieving Blob (Image) from Database




Error java.sql.SQLException: not implemented by SQLite JDBC driver when Retrieving Blob (Image) from Database

When I try to retrieve an image(Blob) file from Sqlite database it gives me these error . I have used many jars , such as rs2xml , sqlitejdbc-v056 , sqlite-jdbc-3.8.11 and … Read the rest “Error java.sql.SQLException: not implemented by SQLite JDBC driver when Retrieving Blob (Image) from Database”

DatabaseMetaData.getColumns() returns empty ResultSet when use table name in lower case,but the right ResultSet in upper




DatabaseMetaData.getColumns() returns empty ResultSet when use table name in lower case,but the right ResultSet in upper

I use oracle 11g,and create a table like this:
create table test1(
id int,
name varchar(10),
inserttime date
)

Then I use the jdbc method
DatabaseMetaData.getColumns(null, null, “test1”, null)… Read the rest “DatabaseMetaData.getColumns() returns empty ResultSet when use table name in lower case,but the right ResultSet in upper”

Are there major scaling limits with play framework and jdbc blocking io calls




Are there major scaling limits with play framework and jdbc blocking io calls

I am using the playframework (2.4) for Java and connecting it to Postgres. The play framework is being used as a restful service and all it is doing is insert,updates,reads and deletes … Read the rest “Are there major scaling limits with play framework and jdbc blocking io calls”