Db2 Sql Error Sqlcode=-302 Sqlstate=22001 Sqlerrmc=6
Contents |
Search Forums Home » Liferay Portal » English » 1. Installation / Deployment sqlstate=22001 sqlcode=-433 / Setup Recent Posts Statistics RSS (Opens New
Sqlstate 22001 String Data Right Truncated
Window) Answer (Unmark) Mark as an Answer Threads [ Previous | Next ] sqlcode=-302, sqlstate=22001 select DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null XINGYI WEI February 2, 2016 1:15 AM RE: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null what is sqlerrmc Jonas Choi February 8, 2016 11:18 AM DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null February 2, 2016 1:15 AM Answer XINGYI WEI Rank: New Member Posts: 1 Join Date: January 4, 2015 Recent Posts Hi Liferay experts,I am keeping hit this challenging when
String Data Right Truncation. Sqlstate=22001
upgrading permissions.user.check.algorithm from 2 to 5. DB2 version 9.7.Our system is 6.0.11 EE. In order to upgrade our Liferay, I have to upgarde permissions.user.check.algorithm first. Set permissions.user.check.algorithm = 5, restart Liferay and click "Execute" in "Legacy Permissions Migration". It keeps failure.Please help. Anyway to bypass?102 二月 2016 00:50:56,213 INFO [Table:432] Finished backup of ResourcePermissionView to C:\demandtec\ts-portal\portal\d2eploy\servers\tomcat\temp/temp-db-ResourcePermissionView-1454403056197 in 16 ms302 二月 2016 00:50:56,215 WARN [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswo4rdportlet#ADD_TO_PAGE502 二月 2016 00:50:56,215 WARN [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswo6rdportlet#ADD_TO_PAGE702 二月 2016 00:50:56,215 WARN [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswo8rdportlet#ADD_TO_PAGE902 二月 2016 00:50:56,216 WARN [ConvertPermissionAlgorithm:405] Could not find resource action Password_WAR_Resetpasswo10rdportlet#ADD_TO_PAGE1102 二月 2016 00:50:56,216 DEBUG [SessionFactoryImpl:68] Session is using connection release mode on_close1202 二月 2016 00:50:56,216 DEBUG [SQLTransformer:163] Original SQL SELECT re
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may http://www.dbforums.com/showthread.php?1652962-Getting-the-error-DB2-SQL-Error-SQLCODE-302-SQLSTATE-22001-SQLERRMC-null have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 4 of 4 Thread: Getting the error DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null Tweet Thread Tools Show Printable Version Subscribe to sql error this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 01-24-10,11:36 #1 chetan1989 View Profile View Forum Posts Registered User Join Date Jan 2010 Posts 4 Unanswered: Getting the error DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null Code: import java.io.File; import java.io.FileInputStream; import java.io.FileNotFoundException; import java.io.InputStream; import java.sql.Connection; db2 sql error import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class BlobUse { Connection connection; Statement statement; ResultSet resultSet; public void generateReport() { try { Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance(); String url = "jdbc:db2://localhost:50000/smartcit"; Connection connection = DriverManager.getConnection(url, "db2admin", "password"); PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO ADMINISTRATOR.BOOKCOVERS VALUES(?,?)"); File imageFile = new File("c:\\redbookcover.jpg"); InputStream inputStream = new FileInputStream(imageFile); preparedStatement.setString(1," 0738425826"); preparedStatement.setBinaryStream(2,inputStream,(int)(imageFile.length())); preparedStatement.executeUpdate(); connection.close(); } catch (FileNotFoundException e) { e.printStackTrace(); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { System.out.println("SQL Exception"); System.out.println("============="); System.out.println(e.getMessage()); // (1) System.out.println(""); }catch (IllegalAccessException ex) {System.err.println(ex.getMessage());} catch (InstantiationException ex) {System.err.println(ex.getMessage());} } public static void main(String[] args) { new BlobUse().generateReport(); } } I created the table using query: create table bookcovers (bookisbn varchar(10) not null, bookcover blob (1G) not null, primary key(bookisbn)) This is the example program from IBM site to store an image on database from IBM site but I am unable to run it sucessfully. Please help Reply With Quote 01-24-10,11:53 #2 shammat View Profile View Forum Posts Registe