nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Session Time Zone bug?

dudumanbog

Hi. Does anybody know how to handle the error with SQLException: Session Time Zone not set! 
I am trying to build a data set that used sql data source. What is the best approach for this problem? Is this a bug? 
 
<blockquote class='ipsBlockquote' >org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the string value from column: 11. 
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get string value in the result set. 
SQL error #1:Session Time Zone not set!</blockquote>
 
 
Thanks!

Find more posts tagged with

Comments

JasonW

Can you try creating a blank report and add a data item with the following expression.
reportContext.getTimeZone().getDisplayName();

What version of BIRT are you using? Did you download the allinone designer?

Jason